﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Assets_czjl] 
	@zcbh varchar(20),
	@StartIndex int,
	@EndIndex INT
AS
BEGIN
	;WITH list as (select ROW_NUMBER() OVER (ORDER BY id desc)AS Row, * from zcjl where zcbh=@zcbh  
)
select *  from list,(Select Count(Id) AS DataCount FROM list
	) AS n where Row between @StartIndex and @EndIndex ORDER BY id desc

END
